OpenEdge Development:<br />Progress 4GL Reference IF...THEN...ELSE function

Release 10.1A: OpenEdge Development:
Progress 4GL Reference

IF...THEN...ELSE function

Evaluates one of two expressions, depending on the value of a specified condition.

Syntax
IF condition THEN expression1 ELSE expression2 
condition
An expression whose value is logical (TRUE or FALSE).
expression1
A constant, field name, variable name, or expression. If the condition is TRUE, then the function returns this value.
expression2
A constant, field name, variable name, or expression whose value is of a data type that is compatible with the data type of expression1. If the condition is FALSE or the Unknown value (?), then the function returns this value.
Example

You can use the IF . . . THEN . . . ELSE function when you want to sort records in an unusual order. In this example, the customers are sorted so that those with a balance greater than $10,000 appear first, then those with balances between $1,000 and $10,000, and finally those with balance of $1,000 or less.
r-ifelsf.p
FOR EACH customer
  BY IF balance > 10000 THEN 1
  ELSE (IF balance > 1000 THEN 2 ELSE 3) BY sales-rep:
  DISPLAY sales-rep balance name.
END. 